package org.dromara.system.mapper;

import org.apache.ibatis.annotations.Select;
import org.dromara.system.domain.WbOperatingProductsList;
import org.dromara.system.domain.vo.WbOperatingProductsListVo;
import org.dromara.common.mybatis.core.mapper.BaseMapperPlus;

import java.io.Serial;
import java.util.List;

/**
 * 各公司经营产品Mapper接口
 *
 * @author Lion Li
 * @date 2024-06-05
 */
public interface WbOperatingProductsListMapper extends BaseMapperPlus<WbOperatingProductsList, WbOperatingProductsListVo> {
    @Select(
        "        select company_id from wb_operating_products_list\n" +
        "        where product_name like concat('%',#{product_name}, '%')\n" +
        "        group by company_id\n" )
    List<Long> selectCompanyIds(String productName);
    @Select("select product_name from wb_operating_products_list where company_id =#{id}")
    List<String> selectProductName(Long id);
}
